BEGIN TRANSACTION
	DELETE FROM PLACE_OF_REST
		WHERE (id = 20)
COMMIT

SELECT * FROM PLACE_OF_REST	
SELECT * FROM SEA_PLACE
SELECT * FROM HOTEL_PLACE 
SELECT * FROM COUNTRY_PLACE 
SELECT * FROM PLACE_TIME WHERE (place_id = 7 or place_id = 30)
SELECT * FROM PLACE_TIME WHERE place_id IN (SELECT PLACE_TOUR.id
												FROM PLACE_TOUR
													JOIN PLACE_OF_REST ON (PLACE_TOUR.place_id = PLACE_OF_REST.id)
												WHERE (place = 'empty'))
SELECT * FROM PLACE_TIME WHERE start_date > CURRENT_TIMESTAMP
UPDATE PLACE_TIME SET
	start_date = '08/08/2015', end_date = '22/08/2015'
	WHERE (place_id = 7) AND (group_id = 4)
select * from hotel where id = 74